UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'moUm82Kzl64AvbeafEx1o0R1zMQg5gtZhUEy/u5lO/c='
WHERE
key_id = '78ef08f9a513a83cf2205404d9f7045028f36bc06de9d2ea436d55968e5ce7bf'
AND (
token = 'moUm82Kzl64AvbeafEx1o0R1zMQg5gtZhUEy/u5lO/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)