UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WxZBVJRRrFuAcMoluLJmyqRQ7/P/xqMSj3V7X8cef4k='
WHERE
key_id = '168948bee5eb16532d3800249a8a06ad911fd2028a49f970a072aeb4f6161c60'
AND (
token = 'WxZBVJRRrFuAcMoluLJmyqRQ7/P/xqMSj3V7X8cef4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)