UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EMDm8KoLzlu7IKHFY6WGq3YWJFURPaRILS+JG5BIXiE='
WHERE
key_id = '6c3b5c320a35be235a746e5128aa24b1987df600c0ead6af6bdc76f2fb33ff17'
AND (
token = 'EMDm8KoLzlu7IKHFY6WGq3YWJFURPaRILS+JG5BIXiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)