UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hruvVPe5+aQ+KAxHW+DB7Zs/OoOQFUIaezod8yNLhj0='
WHERE
key_id = '24d6405a029ae27b3cd9eab44e2d860a8ec2b1dd758c44bd67a6609bc8f6224d'
AND (
token = 'hruvVPe5+aQ+KAxHW+DB7Zs/OoOQFUIaezod8yNLhj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)