UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ja0Jcy9ufQrRkbhyooYEZgYKOJAOZX0eMi1M5E5MTPo='
WHERE
key_id = 'dc9d09b8fb1566947628b0fed33fb9ecb05cfa85ad49c2aed6e761b2fbeef9f5'
AND (
token = 'ja0Jcy9ufQrRkbhyooYEZgYKOJAOZX0eMi1M5E5MTPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)