UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zoFZFnq4TmMh1ZrDjpkiYVEFjnMPmlcLgtIaM5SsQdw='
WHERE
key_id = 'a9f1e40a001c549efcf8f5846d006f19bf244f605b698cc2cee382a4865918e7'
AND (
token = 'zoFZFnq4TmMh1ZrDjpkiYVEFjnMPmlcLgtIaM5SsQdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)