UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oWaubzqsIyy8Z0Fhg/ioZps1zgky0u7RuqpfvNJ4Vnk='
WHERE
key_id = 'f89ce32d912e750e22044366ba0a8abf11109dbe0619d25e9c10ee0af52af046'
AND (
token = 'oWaubzqsIyy8Z0Fhg/ioZps1zgky0u7RuqpfvNJ4Vnk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)