UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lqtEa0FN4zCl5avFVI6drF6bZh7n9F6T/V2OVnRP87U='
WHERE
key_id = 'fdd9ee825cadd7d22039a64262cea371ab6bb47d5050bd606f6090eb20ab27eb'
AND (
token = 'lqtEa0FN4zCl5avFVI6drF6bZh7n9F6T/V2OVnRP87U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)