UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0EfxhIxbrugYQiGDCXHhd2QqbJ9uA9oJxGFcTuEBwmk='
WHERE
key_id = 'b10fb981b5e391ccf376769dec4c5a23737be4e9b10da75093a08b068d8c5e94'
AND (
token = '0EfxhIxbrugYQiGDCXHhd2QqbJ9uA9oJxGFcTuEBwmk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)