UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZseHxijEe7pXAAcQSJUGvDEDdsBedkAWXGYpntJK+JM='
WHERE
key_id = '1686f67f41817ee94c1c98592ebc1d7b32e412dab380e7b59fb768cb8fda199a'
AND (
token = 'ZseHxijEe7pXAAcQSJUGvDEDdsBedkAWXGYpntJK+JM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)