UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EKy1F+aCgavHjq0QoyIpj4BlH5zzs6gM0HlZtHo9oa8='
WHERE
key_id = '66832f6b9832e7e23531f4111ec4a1c72e1bcef31d874c39c9c42676cff1a5db'
AND (
token = 'EKy1F+aCgavHjq0QoyIpj4BlH5zzs6gM0HlZtHo9oa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)