UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'cUJIJeUYxYM3ojVSwciN8ZfAzkTr7TRevK9sMH/wIxQ=' 
WHERE 
  key_id = '0b4dc5c793879e1ce4ce50d8116dd7dbc4a8fb891e00ca4a7834f4886c3af8ec' 
  AND (
    token = 'cUJIJeUYxYM3ojVSwciN8ZfAzkTr7TRevK9sMH/wIxQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033