UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9GvAL/elnE/szwI2DDhpmsAwdvCXs6X7oBnTp5v42U0='
WHERE
key_id = '93072acb98dde84c065270bdbd83be37eecd84ea23909425c58588f5a2dda979'
AND (
token = '9GvAL/elnE/szwI2DDhpmsAwdvCXs6X7oBnTp5v42U0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)