UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZWd+caKTgSG3LcsS9U6rpDxGGZLxo3wWYjhAyFOjasA='
WHERE
key_id = 'd65d23bbfaedff8820ef1facbab78317cdec27eef4f6352d3d548be330f17676'
AND (
token = 'ZWd+caKTgSG3LcsS9U6rpDxGGZLxo3wWYjhAyFOjasA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)