UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zG1o4mtI7jWnCmDnHs7vjorObflgvrmkLECDQC1FRmw='
WHERE
key_id = '31e53eb4e779de581c964f231b6c922011b072893a5edba3506bd60e9d570f03'
AND (
token = 'zG1o4mtI7jWnCmDnHs7vjorObflgvrmkLECDQC1FRmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)