UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '05ZN6tqMxwQpqTgm7kDq1jF5zznxe4yeem0HWyy5VlI=' 
WHERE 
  key_id = '7919624dba2099af3088168a4ccfa73ac1c37ef0a3c7430df593b3c38f6c4e88' 
  AND (
    token = '05ZN6tqMxwQpqTgm7kDq1jF5zznxe4yeem0HWyy5VlI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022