UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZkkOl1EHLNzW+7bc/qaEuLt9E2s1MfXPONPhQd/g3hM='
WHERE
key_id = 'fa745f1425de7ca8a4a2b956646a48746c0d2c1825b41eca6caad1c7e64be846'
AND (
token = 'ZkkOl1EHLNzW+7bc/qaEuLt9E2s1MfXPONPhQd/g3hM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)