UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xQOgJdEZdcbCPN+/gbIu/X+aIqt25En7l2to07hJNoo=' 
WHERE 
  key_id = '50bfeab7cb332bed9f46f72c3cc5bff4b16526a9c2689334d358e6e4aa2cfe5b' 
  AND (
    token = 'xQOgJdEZdcbCPN+/gbIu/X+aIqt25En7l2to07hJNoo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022