UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lPCIiQYD34xp/o1AZnIxgRg+2urEnB+ZpOJl426uYhU='
WHERE
key_id = '6c1f494c5057c49461ac8bee0c65be9e60ca82eca536e9d8a12d8b23226ab556'
AND (
token = 'lPCIiQYD34xp/o1AZnIxgRg+2urEnB+ZpOJl426uYhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)