UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '24y+JstK+oLew4emfDVzK2qVXmczsWx+DDwkGU+CVRs='
WHERE
key_id = '8a9bf4c37e4827aa2ccad98cb9ec053ecf986b1be0bf72fc89d7ad3ae90dd525'
AND (
token = '24y+JstK+oLew4emfDVzK2qVXmczsWx+DDwkGU+CVRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)