UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KfZBn9gz4LH/9ygUP/1Zkd1id32M5YrejLWG6/BIvyg='
WHERE
key_id = 'ddfd077d86dd6744405453b3fb19d754964a0bff34e15a8d6de1f3f7f82c14ba'
AND (
token = 'KfZBn9gz4LH/9ygUP/1Zkd1id32M5YrejLWG6/BIvyg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)