UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'B/yLE+1uUaZ7mM8UC3As/UNM5iFpjD8DvMwjvIDHl+w=' 
WHERE 
  key_id = 'c8fc7cec65b33b3a4e52f714222108838a58edbba1fea20a3a9f5f372bdb578d' 
  AND (
    token = 'B/yLE+1uUaZ7mM8UC3As/UNM5iFpjD8DvMwjvIDHl+w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042