UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z7NQ/2S9xwFvlKkYwb6goqEZPKcyLnGj3Mdjgu2dfdA='
WHERE
key_id = '1c862b93386d4144b030523e58269229cf28b2ea21ca09547f3d426c6d51ff66'
AND (
token = 'z7NQ/2S9xwFvlKkYwb6goqEZPKcyLnGj3Mdjgu2dfdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)