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