UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jC7MluKad4/LPBo0kg9l7NXUvVvRFYljKQJUxe411EY=' 
WHERE 
  key_id = '7a708e1631a92f0d5a4a481a48a54979217c29f9a78d365bb40c7eaa0ea4c46a' 
  AND (
    token = 'jC7MluKad4/LPBo0kg9l7NXUvVvRFYljKQJUxe411EY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00053