UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W7VmTMzo8eI2R+IFHSRlwl/5CAYfK0TXLpFQYg4KCIU='
WHERE
key_id = '305044fc3244c1c2799ff6b7caa73ab6e322b7e787de933a19c7c738c44109a3'
AND (
token = 'W7VmTMzo8eI2R+IFHSRlwl/5CAYfK0TXLpFQYg4KCIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)