UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gktFrfyReWa4wS9/Uw16AU0G9ZoUdTxlFu68mlKgna8='
WHERE
key_id = '7afca9e806090986463ae2d7d69867e0bd60ca29b5b442169460107ecdf379c7'
AND (
token = 'gktFrfyReWa4wS9/Uw16AU0G9ZoUdTxlFu68mlKgna8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)