UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dksvqG5SXJlkZoFGFzcXviIldvP210DGPtefhcVcsSY='
WHERE
key_id = '7dc7ed8f2e58e462c5f53b8e548bb6a7080e8975d4bc4f9df57914700960f119'
AND (
token = 'dksvqG5SXJlkZoFGFzcXviIldvP210DGPtefhcVcsSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)