UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7BDoj8bX5FMivVRZDEFB4CSQicXnrHvIKOCvAt+p6gE='
WHERE
key_id = 'e6f0d57047bdd4befb857943c9213fc3919f05194fa98772772b87d003c2bf4e'
AND (
token = '7BDoj8bX5FMivVRZDEFB4CSQicXnrHvIKOCvAt+p6gE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)