UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BQKsNkOqM4TeEE6A2Q7tvtpzJcEJsvy87yK7+Al8J6I='
WHERE
key_id = '8e2d907cf7ec6744b76b8f30d4b014812ef597e328eac7d1de65d846744e31f2'
AND (
token = 'BQKsNkOqM4TeEE6A2Q7tvtpzJcEJsvy87yK7+Al8J6I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)