UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XN+qTnp2MXEm08YEczKFGyw377It9Tw1A1vvQ6WW/ZA='
WHERE
key_id = '97115b76e77e7126a04752803d44ec3d4bded67e3b395aeae9786b71f910eeb7'
AND (
token = 'XN+qTnp2MXEm08YEczKFGyw377It9Tw1A1vvQ6WW/ZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)