UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5drhODi9dKDTs8OvyBov7FpSjp1q1es+drDir/rwN74='
WHERE
key_id = '5d514a9238673739d893fd5e0fbe4dd429d7180aaa2ababa975831bdd1a98ba0'
AND (
token = '5drhODi9dKDTs8OvyBov7FpSjp1q1es+drDir/rwN74='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)