UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DfUx0/5je8XP+K1cZU9T+mu9dRXdfhf5x7wHMm1HLFw='
WHERE
key_id = 'fc1d7aaec6f0fa067a1e10436e06f5d08ec3003dfc5466ad94c2beefa4e109df'
AND (
token = 'DfUx0/5je8XP+K1cZU9T+mu9dRXdfhf5x7wHMm1HLFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)